﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsTongQuan" targetNamespace="http://tempuri.org/dsTongQuan.xsd" xmlns:mstns="http://tempuri.org/dsTongQuan.xsd" xmlns="http://tempuri.org/dsTongQuan.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCrewTableAdapter" GeneratorDataComponentClassName="tblCrewTableAdapter" Name="tblCrew" UserDataComponentName="tblCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCrew] WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_nRankID = 1 AND [nRankID] IS NULL) OR ([nRankID] = @Original_nRankID)) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cCMT = 1 AND [cCMT] IS NULL) OR ([cCMT] = @Original_cCMT)) AND ((@IsNull_dNgayCap = 1 AND [dNgayCap] IS NULL) OR ([dNgayCap] = @Original_dNgayCap)) AND ((@IsNull_nNoiCap = 1 AND [nNoiCap] IS NULL) OR ([nNoiCap] = @Original_nNoiCap)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSex = 1 AND [cSex] IS NULL) OR ([cSex] = @Original_cSex)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)) AND ((@IsNull_bDeleted = 1 AND [bDeleted] IS NULL) OR ([bDeleted] = @Original_bDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgayCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nNoiCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCrew] ([nCrewId], [nRankID], [iCrewType], [bImage], [cFamilyName], [cMiddleName], [cFirstName], [cCMT], [dNgayCap], [nNoiCap], [cAlias], [dDateOfBirth], [cAddress], [cPlaceOfBirth], [cHomeNo], [cHandNo], [cEmail], [cSex], [cMaritalStatus], [cNationality], [cContactPerson], [cContactPersonAddress], [cContactPersonNo], [cContactRelation], [cContactEmail], [fHeight], [fWeight], [cBloodGroup], [fShoeSizeVN], [fShoeSizeJP], [fOverallSizeVN], [cOverallSizeJP], [bDeleted]) VALUES (@nCrewId, @nRankID, @iCrewType, @bImage, @cFamilyName, @cMiddleName, @cFirstName, @cCMT, @dNgayCap, @nNoiCap, @cAlias, @dDateOfBirth, @cAddress, @cPlaceOfBirth, @cHomeNo, @cHandNo, @cEmail, @cSex, @cMaritalStatus, @cNationality, @cContactPerson, @cContactPersonAddress, @cContactPersonNo, @cContactRelation, @cContactEmail, @fHeight, @fWeight, @cBloodGroup, @fShoeSizeVN, @fShoeSizeJP, @fOverallSizeVN, @cOverallSizeJP, @bDeleted);
SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted FROM dbo.tblCrew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCrew] SET [nCrewId] = @nCrewId, [nRankID] = @nRankID, [iCrewType] = @iCrewType, [bImage] = @bImage, [cFamilyName] = @cFamilyName, [cMiddleName] = @cMiddleName, [cFirstName] = @cFirstName, [cCMT] = @cCMT, [dNgayCap] = @dNgayCap, [nNoiCap] = @nNoiCap, [cAlias] = @cAlias, [dDateOfBirth] = @dDateOfBirth, [cAddress] = @cAddress, [cPlaceOfBirth] = @cPlaceOfBirth, [cHomeNo] = @cHomeNo, [cHandNo] = @cHandNo, [cEmail] = @cEmail, [cSex] = @cSex, [cMaritalStatus] = @cMaritalStatus, [cNationality] = @cNationality, [cContactPerson] = @cContactPerson, [cContactPersonAddress] = @cContactPersonAddress, [cContactPersonNo] = @cContactPersonNo, [cContactRelation] = @cContactRelation, [cContactEmail] = @cContactEmail, [fHeight] = @fHeight, [fWeight] = @fWeight, [cBloodGroup] = @cBloodGroup, [fShoeSizeVN] = @fShoeSizeVN, [fShoeSizeJP] = @fShoeSizeJP, [fOverallSizeVN] = @fOverallSizeVN, [cOverallSizeJP] = @cOverallSizeJP, [bDeleted] = @bDeleted WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_nRankID = 1 AND [nRankID] IS NULL) OR ([nRankID] = @Original_nRankID)) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cCMT = 1 AND [cCMT] IS NULL) OR ([cCMT] = @Original_cCMT)) AND ((@IsNull_dNgayCap = 1 AND [dNgayCap] IS NULL) OR ([dNgayCap] = @Original_dNgayCap)) AND ((@IsNull_nNoiCap = 1 AND [nNoiCap] IS NULL) OR ([nNoiCap] = @Original_nNoiCap)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSex = 1 AND [cSex] IS NULL) OR ([cSex] = @Original_cSex)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)) AND ((@IsNull_bDeleted = 1 AND [bDeleted] IS NULL) OR ([bDeleted] = @Original_bDeleted)));
SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgayCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nNoiCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="iCrewType" DataSetColumn="iCrewType" />
              <Mapping SourceColumn="bImage" DataSetColumn="bImage" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cCMT" DataSetColumn="cCMT" />
              <Mapping SourceColumn="dNgayCap" DataSetColumn="dNgayCap" />
              <Mapping SourceColumn="nNoiCap" DataSetColumn="nNoiCap" />
              <Mapping SourceColumn="cAlias" DataSetColumn="cAlias" />
              <Mapping SourceColumn="dDateOfBirth" DataSetColumn="dDateOfBirth" />
              <Mapping SourceColumn="cAddress" DataSetColumn="cAddress" />
              <Mapping SourceColumn="cPlaceOfBirth" DataSetColumn="cPlaceOfBirth" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cEmail" DataSetColumn="cEmail" />
              <Mapping SourceColumn="cSex" DataSetColumn="cSex" />
              <Mapping SourceColumn="cMaritalStatus" DataSetColumn="cMaritalStatus" />
              <Mapping SourceColumn="cNationality" DataSetColumn="cNationality" />
              <Mapping SourceColumn="cContactPerson" DataSetColumn="cContactPerson" />
              <Mapping SourceColumn="cContactPersonAddress" DataSetColumn="cContactPersonAddress" />
              <Mapping SourceColumn="cContactPersonNo" DataSetColumn="cContactPersonNo" />
              <Mapping SourceColumn="cContactRelation" DataSetColumn="cContactRelation" />
              <Mapping SourceColumn="cContactEmail" DataSetColumn="cContactEmail" />
              <Mapping SourceColumn="fHeight" DataSetColumn="fHeight" />
              <Mapping SourceColumn="fWeight" DataSetColumn="fWeight" />
              <Mapping SourceColumn="cBloodGroup" DataSetColumn="cBloodGroup" />
              <Mapping SourceColumn="fShoeSizeVN" DataSetColumn="fShoeSizeVN" />
              <Mapping SourceColumn="fShoeSizeJP" DataSetColumn="fShoeSizeJP" />
              <Mapping SourceColumn="fOverallSizeVN" DataSetColumn="fOverallSizeVN" />
              <Mapping SourceColumn="cOverallSizeJP" DataSetColumn="cOverallSizeJP" />
              <Mapping SourceColumn="bDeleted" DataSetColumn="bDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblLichHenTableAdapter" GeneratorDataComponentClassName="tblLichHenTableAdapter" Name="tblLichHen" UserDataComponentName="tblLichHenTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblLichHen" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblLichHen] WHERE (([id] = @Original_id) AND ((@IsNull_Ngày = 1 AND [Ngày] IS NULL) OR ([Ngày] = @Original_Ngày)) AND ((@IsNull_Giờ = 1 AND [Giờ] IS NULL) OR ([Giờ] = @Original_Giờ)) AND ((@IsNull_Người_lập_kế_hoạch = 1 AND [Người lập kế hoạch] IS NULL) OR ([Người lập kế hoạch] = @Original_Người_lập_kế_hoạch)) AND ((@IsNull_Mã_thuyền_viên = 1 AND [Mã thuyền viên] IS NULL) OR ([Mã thuyền viên] = @Original_Mã_thuyền_viên)) AND ((@IsNull_Đã_giải_quyết = 1 AND [Đã giải quyết] IS NULL) OR ([Đã giải quyết] = @Original_Đã_giải_quyết)) AND ((@IsNull_Rank = 1 AND [Rank] IS NULL) OR ([Rank] = @Original_Rank)) AND ((@IsNull_Họ_Và_Tên = 1 AND [Họ Và Tên] IS NULL) OR ([Họ Và Tên] = @Original_Họ_Và_Tên)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Ngày" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Ngày" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Giờ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Giờ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Giờ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Giờ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Người_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mã_thuyền_viên" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mã thuyền viên" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Mã_thuyền_viên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mã thuyền viên" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đã_giải_quyết" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đã giải quyết" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Đã_giải_quyết" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã giải quyết" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rank" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rank" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Rank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Họ_Và_Tên" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Họ Và Tên" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Họ_Và_Tên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Họ Và Tên" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblLichHen] ([Ngày], [Giờ], [Nội dung công việc], [Người lập kế hoạch], [Mã thuyền viên], [Đã giải quyết], [Rank], [Họ Và Tên]) VALUES (@Ngày, @Giờ, @Nội_dung_công_việc, @Người_lập_kế_hoạch, @Mã_thuyền_viên, @Đã_giải_quyết, @Rank, @Họ_Và_Tên);
SELECT id, Ngày, Giờ, MONTH(Ngày) AS Tháng, YEAR(Ngày) AS Năm, [Nội dung công việc], [Người lập kế hoạch], [Mã thuyền viên], [Đã giải quyết], Rank, [Họ Và Tên] FROM tblLichHen WHERE (id = SCOPE_IDENTITY()) ORDER BY Ngày, [Đã giải quyết] DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Ngày" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Ngày" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Giờ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Giờ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nội_dung_công_việc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nội dung công việc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mã_thuyền_viên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mã thuyền viên" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Đã_giải_quyết" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã giải quyết" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Rank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Họ_Và_Tên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Họ Và Tên" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        id, Ngày, Giờ, MONTH(Ngày) AS Tháng, YEAR(Ngày) AS Năm, [Nội dung công việc], [Người lập kế hoạch], [Mã thuyền viên], [Đã giải quyết], Rank, [Họ Và Tên]
FROM            tblLichHen
ORDER BY Ngày, [Đã giải quyết] DESC</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblLichHen] SET [Ngày] = @Ngày, [Giờ] = @Giờ, [Nội dung công việc] = @Nội_dung_công_việc, [Người lập kế hoạch] = @Người_lập_kế_hoạch, [Mã thuyền viên] = @Mã_thuyền_viên, [Đã giải quyết] = @Đã_giải_quyết, [Rank] = @Rank, [Họ Và Tên] = @Họ_Và_Tên WHERE (([id] = @Original_id) AND ((@IsNull_Ngày = 1 AND [Ngày] IS NULL) OR ([Ngày] = @Original_Ngày)) AND ((@IsNull_Giờ = 1 AND [Giờ] IS NULL) OR ([Giờ] = @Original_Giờ)) AND ((@IsNull_Người_lập_kế_hoạch = 1 AND [Người lập kế hoạch] IS NULL) OR ([Người lập kế hoạch] = @Original_Người_lập_kế_hoạch)) AND ((@IsNull_Mã_thuyền_viên = 1 AND [Mã thuyền viên] IS NULL) OR ([Mã thuyền viên] = @Original_Mã_thuyền_viên)) AND ((@IsNull_Đã_giải_quyết = 1 AND [Đã giải quyết] IS NULL) OR ([Đã giải quyết] = @Original_Đã_giải_quyết)) AND ((@IsNull_Rank = 1 AND [Rank] IS NULL) OR ([Rank] = @Original_Rank)) AND ((@IsNull_Họ_Và_Tên = 1 AND [Họ Và Tên] IS NULL) OR ([Họ Và Tên] = @Original_Họ_Và_Tên)));
SELECT id, Ngày, Giờ, MONTH(Ngày) AS Tháng, YEAR(Ngày) AS Năm, [Nội dung công việc], [Người lập kế hoạch], [Mã thuyền viên], [Đã giải quyết], Rank, [Họ Và Tên] FROM tblLichHen WHERE (id = @id) ORDER BY Ngày, [Đã giải quyết] DESC</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Ngày" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Ngày" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Giờ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Giờ" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Nội_dung_công_việc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Nội dung công việc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Mã_thuyền_viên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mã thuyền viên" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Đã_giải_quyết" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã giải quyết" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Rank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rank" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Họ_Và_Tên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Họ Và Tên" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Ngày" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Ngày" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Ngày" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Ngày" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Giờ" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Giờ" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Giờ" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="Giờ" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Người_lập_kế_hoạch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Người_lập_kế_hoạch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Người lập kế hoạch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mã_thuyền_viên" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mã thuyền viên" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Mã_thuyền_viên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Mã thuyền viên" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Đã_giải_quyết" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Đã giải quyết" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Đã_giải_quyết" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Đã giải quyết" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rank" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rank" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Rank" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Rank" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Họ_Và_Tên" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Họ Và Tên" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Họ_Và_Tên" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Họ Và Tên" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="id" DataSourceName="CrewManagment.dbo.tblLichHen" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="Ngày" DataSetColumn="Ngày" />
              <Mapping SourceColumn="Giờ" DataSetColumn="Giờ" />
              <Mapping SourceColumn="Nội dung công việc" DataSetColumn="Nội dung công việc" />
              <Mapping SourceColumn="Người lập kế hoạch" DataSetColumn="Người lập kế hoạch" />
              <Mapping SourceColumn="Mã thuyền viên" DataSetColumn="Mã thuyền viên" />
              <Mapping SourceColumn="Đã giải quyết" DataSetColumn="Đã giải quyết" />
              <Mapping SourceColumn="Tháng" DataSetColumn="Tháng" />
              <Mapping SourceColumn="Năm" DataSetColumn="Năm" />
              <Mapping SourceColumn="Rank" DataSetColumn="Rank" />
              <Mapping SourceColumn="Họ Và Tên" DataSetColumn="Họ Và Tên" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblAssignmentTableAdapter" GeneratorDataComponentClassName="tblAssignmentTableAdapter" Name="tblAssignment" UserDataComponentName="tblAssignmentTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblAssignment" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblAssignment] WHERE (([nAssignmentId] = @Original_nAssignmentId) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_cStatus = 1 AND [cStatus] IS NULL) OR ([cStatus] = @Original_cStatus)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_dEmbarked = 1 AND [dEmbarked] IS NULL) OR ([dEmbarked] = @Original_dEmbarked)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dLeave = 1 AND [dLeave] IS NULL) OR ([dLeave] = @Original_dLeave)) AND ((@IsNull_nRequest = 1 AND [nRequest] IS NULL) OR ([nRequest] = @Original_nRequest)) AND ((@IsNull_dDuKienRoiTau = 1 AND [dDuKienRoiTau] IS NULL) OR ([dDuKienRoiTau] = @Original_dDuKienRoiTau)) AND ((@IsNull_dSanSangLenTau = 1 AND [dSanSangLenTau] IS NULL) OR ([dSanSangLenTau] = @Original_dSanSangLenTau)) AND ((@IsNull_dCatHopDong = 1 AND [dCatHopDong] IS NULL) OR ([dCatHopDong] = @Original_dCatHopDong)) AND ((@IsNull_dNghiHuu = 1 AND [dNghiHuu] IS NULL) OR ([dNghiHuu] = @Original_dNghiHuu)) AND ((@IsNull_dKyHopDong = 1 AND [dKyHopDong] IS NULL) OR ([dKyHopDong] = @Original_dKyHopDong)) AND ((@IsNull_dModified = 1 AND [dModified] IS NULL) OR ([dModified] = @Original_dModified)) AND ((@IsNull_isActive = 1 AND [isActive] IS NULL) OR ([isActive] = @Original_isActive)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dLeave" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dSanSangLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dCatHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNghiHuu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dKyHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblAssignment] ([nCrewid], [nVesselId], [cStatus], [cDescription], [dEmbarked], [nContract], [dLeave], [nRequest], [dDuKienRoiTau], [dSanSangLenTau], [dCatHopDong], [dNghiHuu], [dKyHopDong], [dModified], [isActive]) VALUES (@nCrewid, @nVesselId, @cStatus, @cDescription, @dEmbarked, @nContract, @dLeave, @nRequest, @dDuKienRoiTau, @dSanSangLenTau, @dCatHopDong, @dNghiHuu, @dKyHopDong, @dModified, @isActive);
SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive FROM tblAssignment WHERE (nAssignmentId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive FROM dbo.tblAssignment</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblAssignment] SET [nCrewid] = @nCrewid, [nVesselId] = @nVesselId, [cStatus] = @cStatus, [cDescription] = @cDescription, [dEmbarked] = @dEmbarked, [nContract] = @nContract, [dLeave] = @dLeave, [nRequest] = @nRequest, [dDuKienRoiTau] = @dDuKienRoiTau, [dSanSangLenTau] = @dSanSangLenTau, [dCatHopDong] = @dCatHopDong, [dNghiHuu] = @dNghiHuu, [dKyHopDong] = @dKyHopDong, [dModified] = @dModified, [isActive] = @isActive WHERE (([nAssignmentId] = @Original_nAssignmentId) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_nVesselId = 1 AND [nVesselId] IS NULL) OR ([nVesselId] = @Original_nVesselId)) AND ((@IsNull_cStatus = 1 AND [cStatus] IS NULL) OR ([cStatus] = @Original_cStatus)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)) AND ((@IsNull_dEmbarked = 1 AND [dEmbarked] IS NULL) OR ([dEmbarked] = @Original_dEmbarked)) AND ((@IsNull_nContract = 1 AND [nContract] IS NULL) OR ([nContract] = @Original_nContract)) AND ((@IsNull_dLeave = 1 AND [dLeave] IS NULL) OR ([dLeave] = @Original_dLeave)) AND ((@IsNull_nRequest = 1 AND [nRequest] IS NULL) OR ([nRequest] = @Original_nRequest)) AND ((@IsNull_dDuKienRoiTau = 1 AND [dDuKienRoiTau] IS NULL) OR ([dDuKienRoiTau] = @Original_dDuKienRoiTau)) AND ((@IsNull_dSanSangLenTau = 1 AND [dSanSangLenTau] IS NULL) OR ([dSanSangLenTau] = @Original_dSanSangLenTau)) AND ((@IsNull_dCatHopDong = 1 AND [dCatHopDong] IS NULL) OR ([dCatHopDong] = @Original_dCatHopDong)) AND ((@IsNull_dNghiHuu = 1 AND [dNghiHuu] IS NULL) OR ([dNghiHuu] = @Original_dNghiHuu)) AND ((@IsNull_dKyHopDong = 1 AND [dKyHopDong] IS NULL) OR ([dKyHopDong] = @Original_dKyHopDong)) AND ((@IsNull_dModified = 1 AND [dModified] IS NULL) OR ([dModified] = @Original_dModified)) AND ((@IsNull_isActive = 1 AND [isActive] IS NULL) OR ([isActive] = @Original_isActive)));
SELECT nAssignmentId, nCrewid, nVesselId, cStatus, cDescription, dEmbarked, nContract, dLeave, nRequest, dDuKienRoiTau, dSanSangLenTau, dCatHopDong, dNghiHuu, dKyHopDong, dModified, isActive FROM tblAssignment WHERE (nAssignmentId = @nAssignmentId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cStatus" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dEmbarked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dEmbarked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dEmbarked" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContract" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContract" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dLeave" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dLeave" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dLeave" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRequest" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRequest" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDuKienRoiTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDuKienRoiTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDuKienRoiTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dSanSangLenTau" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dSanSangLenTau" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dSanSangLenTau" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dCatHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dCatHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dCatHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNghiHuu" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNghiHuu" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dNghiHuu" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dKyHopDong" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dKyHopDong" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dKyHopDong" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dModified" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dModified" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dModified" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isActive" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_isActive" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="isActive" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nAssignmentId" ColumnName="nAssignmentId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nAssignmentId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nAssignmentId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nAssignmentId" DataSetColumn="nAssignmentId" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
              <Mapping SourceColumn="dEmbarked" DataSetColumn="dEmbarked" />
              <Mapping SourceColumn="nContract" DataSetColumn="nContract" />
              <Mapping SourceColumn="dLeave" DataSetColumn="dLeave" />
              <Mapping SourceColumn="nRequest" DataSetColumn="nRequest" />
              <Mapping SourceColumn="dDuKienRoiTau" DataSetColumn="dDuKienRoiTau" />
              <Mapping SourceColumn="dSanSangLenTau" DataSetColumn="dSanSangLenTau" />
              <Mapping SourceColumn="dCatHopDong" DataSetColumn="dCatHopDong" />
              <Mapping SourceColumn="dNghiHuu" DataSetColumn="dNghiHuu" />
              <Mapping SourceColumn="dKyHopDong" DataSetColumn="dKyHopDong" />
              <Mapping SourceColumn="dModified" DataSetColumn="dModified" />
              <Mapping SourceColumn="isActive" DataSetColumn="isActive" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsTongQuan" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsTongQuan" msprop:Generator_UserDSName="dsTongQuan">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblCrew" msprop:Generator_TableClassName="tblCrewDataTable" msprop:Generator_TableVarName="tabletblCrew" msprop:Generator_TablePropName="tblCrew" msprop:Generator_RowDeletingName="tblCrewRowDeleting" msprop:Generator_UserTableName="tblCrew" msprop:Generator_RowChangingName="tblCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewRowDeleted" msprop:Generator_RowEvArgName="tblCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCrewRowChanged" msprop:Generator_RowClassName="tblCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="iCrewType" msprop:Generator_ColumnVarNameInTable="columniCrewType" msprop:Generator_ColumnPropNameInRow="iCrewType" msprop:Generator_ColumnPropNameInTable="iCrewTypeColumn" msprop:Generator_UserColumnName="iCrewType" type="xs:int" minOccurs="0" />
              <xs:element name="bImage" msprop:Generator_ColumnVarNameInTable="columnbImage" msprop:Generator_ColumnPropNameInRow="bImage" msprop:Generator_ColumnPropNameInTable="bImageColumn" msprop:Generator_UserColumnName="bImage" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cCMT" msprop:Generator_ColumnVarNameInTable="columncCMT" msprop:Generator_ColumnPropNameInRow="cCMT" msprop:Generator_ColumnPropNameInTable="cCMTColumn" msprop:Generator_UserColumnName="cCMT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dNgayCap" msprop:Generator_ColumnVarNameInTable="columndNgayCap" msprop:Generator_ColumnPropNameInRow="dNgayCap" msprop:Generator_ColumnPropNameInTable="dNgayCapColumn" msprop:Generator_UserColumnName="dNgayCap" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nNoiCap" msprop:Generator_ColumnVarNameInTable="columnnNoiCap" msprop:Generator_ColumnPropNameInRow="nNoiCap" msprop:Generator_ColumnPropNameInTable="nNoiCapColumn" msprop:Generator_UserColumnName="nNoiCap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cAlias" msprop:Generator_ColumnVarNameInTable="columncAlias" msprop:Generator_ColumnPropNameInRow="cAlias" msprop:Generator_ColumnPropNameInTable="cAliasColumn" msprop:Generator_UserColumnName="cAlias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfBirth" msprop:Generator_ColumnVarNameInTable="columndDateOfBirth" msprop:Generator_ColumnPropNameInRow="dDateOfBirth" msprop:Generator_ColumnPropNameInTable="dDateOfBirthColumn" msprop:Generator_UserColumnName="dDateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cAddress" msprop:Generator_ColumnVarNameInTable="columncAddress" msprop:Generator_ColumnPropNameInRow="cAddress" msprop:Generator_ColumnPropNameInTable="cAddressColumn" msprop:Generator_UserColumnName="cAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPlaceOfBirth" msprop:Generator_ColumnVarNameInTable="columncPlaceOfBirth" msprop:Generator_ColumnPropNameInRow="cPlaceOfBirth" msprop:Generator_ColumnPropNameInTable="cPlaceOfBirthColumn" msprop:Generator_UserColumnName="cPlaceOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cEmail" msprop:Generator_ColumnVarNameInTable="columncEmail" msprop:Generator_ColumnPropNameInRow="cEmail" msprop:Generator_ColumnPropNameInTable="cEmailColumn" msprop:Generator_UserColumnName="cEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cSex" msprop:Generator_ColumnVarNameInTable="columncSex" msprop:Generator_ColumnPropNameInRow="cSex" msprop:Generator_ColumnPropNameInTable="cSexColumn" msprop:Generator_UserColumnName="cSex" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMaritalStatus" msprop:Generator_ColumnVarNameInTable="columncMaritalStatus" msprop:Generator_ColumnPropNameInRow="cMaritalStatus" msprop:Generator_ColumnPropNameInTable="cMaritalStatusColumn" msprop:Generator_UserColumnName="cMaritalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNationality" msprop:Generator_ColumnVarNameInTable="columncNationality" msprop:Generator_ColumnPropNameInRow="cNationality" msprop:Generator_ColumnPropNameInTable="cNationalityColumn" msprop:Generator_UserColumnName="cNationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPerson" msprop:Generator_ColumnVarNameInTable="columncContactPerson" msprop:Generator_ColumnPropNameInRow="cContactPerson" msprop:Generator_ColumnPropNameInTable="cContactPersonColumn" msprop:Generator_UserColumnName="cContactPerson" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonAddress" msprop:Generator_ColumnVarNameInTable="columncContactPersonAddress" msprop:Generator_ColumnPropNameInRow="cContactPersonAddress" msprop:Generator_ColumnPropNameInTable="cContactPersonAddressColumn" msprop:Generator_UserColumnName="cContactPersonAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonNo" msprop:Generator_ColumnVarNameInTable="columncContactPersonNo" msprop:Generator_ColumnPropNameInRow="cContactPersonNo" msprop:Generator_ColumnPropNameInTable="cContactPersonNoColumn" msprop:Generator_UserColumnName="cContactPersonNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactRelation" msprop:Generator_ColumnVarNameInTable="columncContactRelation" msprop:Generator_ColumnPropNameInRow="cContactRelation" msprop:Generator_ColumnPropNameInTable="cContactRelationColumn" msprop:Generator_UserColumnName="cContactRelation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactEmail" msprop:Generator_ColumnVarNameInTable="columncContactEmail" msprop:Generator_ColumnPropNameInRow="cContactEmail" msprop:Generator_ColumnPropNameInTable="cContactEmailColumn" msprop:Generator_UserColumnName="cContactEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fHeight" msprop:Generator_ColumnVarNameInTable="columnfHeight" msprop:Generator_ColumnPropNameInRow="fHeight" msprop:Generator_ColumnPropNameInTable="fHeightColumn" msprop:Generator_UserColumnName="fHeight" type="xs:double" minOccurs="0" />
              <xs:element name="fWeight" msprop:Generator_ColumnVarNameInTable="columnfWeight" msprop:Generator_ColumnPropNameInRow="fWeight" msprop:Generator_ColumnPropNameInTable="fWeightColumn" msprop:Generator_UserColumnName="fWeight" type="xs:double" minOccurs="0" />
              <xs:element name="cBloodGroup" msprop:Generator_ColumnVarNameInTable="columncBloodGroup" msprop:Generator_ColumnPropNameInRow="cBloodGroup" msprop:Generator_ColumnPropNameInTable="cBloodGroupColumn" msprop:Generator_UserColumnName="cBloodGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fShoeSizeVN" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeVN" msprop:Generator_ColumnPropNameInRow="fShoeSizeVN" msprop:Generator_ColumnPropNameInTable="fShoeSizeVNColumn" msprop:Generator_UserColumnName="fShoeSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="fShoeSizeJP" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeJP" msprop:Generator_ColumnPropNameInRow="fShoeSizeJP" msprop:Generator_ColumnPropNameInTable="fShoeSizeJPColumn" msprop:Generator_UserColumnName="fShoeSizeJP" type="xs:double" minOccurs="0" />
              <xs:element name="fOverallSizeVN" msprop:Generator_ColumnVarNameInTable="columnfOverallSizeVN" msprop:Generator_ColumnPropNameInRow="fOverallSizeVN" msprop:Generator_ColumnPropNameInTable="fOverallSizeVNColumn" msprop:Generator_UserColumnName="fOverallSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="cOverallSizeJP" msprop:Generator_ColumnVarNameInTable="columncOverallSizeJP" msprop:Generator_ColumnPropNameInRow="cOverallSizeJP" msprop:Generator_ColumnPropNameInTable="cOverallSizeJPColumn" msprop:Generator_UserColumnName="cOverallSizeJP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bDeleted" msprop:Generator_ColumnVarNameInTable="columnbDeleted" msprop:Generator_ColumnPropNameInRow="bDeleted" msprop:Generator_ColumnPropNameInTable="bDeletedColumn" msprop:Generator_UserColumnName="bDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblLichHen" msprop:Generator_TableClassName="tblLichHenDataTable" msprop:Generator_TableVarName="tabletblLichHen" msprop:Generator_TablePropName="tblLichHen" msprop:Generator_RowDeletingName="tblLichHenRowDeleting" msprop:Generator_UserTableName="tblLichHen" msprop:Generator_RowChangingName="tblLichHenRowChanging" msprop:Generator_RowEvHandlerName="tblLichHenRowChangeEventHandler" msprop:Generator_RowDeletedName="tblLichHenRowDeleted" msprop:Generator_RowEvArgName="tblLichHenRowChangeEvent" msprop:Generator_RowChangedName="tblLichHenRowChanged" msprop:Generator_RowClassName="tblLichHenRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="Ngày" msprop:Generator_ColumnVarNameInTable="columnNgày" msprop:Generator_ColumnPropNameInRow="Ngày" msprop:Generator_ColumnPropNameInTable="NgàyColumn" msprop:Generator_UserColumnName="Ngày" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Giờ" msprop:Generator_ColumnVarNameInTable="columnGiờ" msprop:Generator_ColumnPropNameInRow="Giờ" msprop:Generator_ColumnPropNameInTable="GiờColumn" msprop:Generator_UserColumnName="Giờ" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Nội_x0020_dung_x0020_công_x0020_việc" msprop:Generator_ColumnVarNameInTable="columnNội_dung_công_việc" msprop:Generator_ColumnPropNameInRow="Nội_dung_công_việc" msprop:Generator_ColumnPropNameInTable="Nội_dung_công_việcColumn" msprop:Generator_UserColumnName="Nội dung công việc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Người_x0020_lập_x0020_kế_x0020_hoạch" msprop:Generator_ColumnVarNameInTable="columnNgười_lập_kế_hoạch" msprop:Generator_ColumnPropNameInRow="Người_lập_kế_hoạch" msprop:Generator_ColumnPropNameInTable="Người_lập_kế_hoạchColumn" msprop:Generator_UserColumnName="Người lập kế hoạch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mã_x0020_thuyền_x0020_viên" msprop:Generator_ColumnVarNameInTable="columnMã_thuyền_viên" msprop:Generator_ColumnPropNameInRow="Mã_thuyền_viên" msprop:Generator_ColumnPropNameInTable="Mã_thuyền_viênColumn" msprop:Generator_UserColumnName="Mã thuyền viên" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Đã_x0020_giải_x0020_quyết" msprop:Generator_ColumnVarNameInTable="columnĐã_giải_quyết" msprop:Generator_ColumnPropNameInRow="Đã_giải_quyết" msprop:Generator_ColumnPropNameInTable="Đã_giải_quyếtColumn" msprop:Generator_UserColumnName="Đã giải quyết" type="xs:boolean" default="false" minOccurs="0" />
              <xs:element name="Tháng" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnTháng" msprop:Generator_ColumnPropNameInRow="Tháng" msprop:Generator_ColumnPropNameInTable="ThángColumn" msprop:Generator_UserColumnName="Tháng" type="xs:int" minOccurs="0" />
              <xs:element name="Năm" msdata:ReadOnly="true" msprop:Generator_ColumnVarNameInTable="columnNăm" msprop:Generator_ColumnPropNameInRow="Năm" msprop:Generator_ColumnPropNameInTable="NămColumn" msprop:Generator_UserColumnName="Năm" type="xs:int" minOccurs="0" />
              <xs:element name="Rank" msprop:Generator_ColumnVarNameInTable="columnRank" msprop:Generator_ColumnPropNameInRow="Rank" msprop:Generator_ColumnPropNameInTable="RankColumn" msprop:Generator_UserColumnName="Rank" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Họ_x0020_Và_x0020_Tên" msprop:Generator_ColumnVarNameInTable="columnHọ_Và_Tên" msprop:Generator_ColumnPropNameInRow="Họ_Và_Tên" msprop:Generator_ColumnPropNameInTable="Họ_Và_TênColumn" msprop:Generator_UserColumnName="Họ Và Tên" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblAssignment" msprop:Generator_TableClassName="tblAssignmentDataTable" msprop:Generator_TableVarName="tabletblAssignment" msprop:Generator_TablePropName="tblAssignment" msprop:Generator_RowDeletingName="tblAssignmentRowDeleting" msprop:Generator_UserTableName="tblAssignment" msprop:Generator_RowChangingName="tblAssignmentRowChanging" msprop:Generator_RowEvHandlerName="tblAssignmentRowChangeEventHandler" msprop:Generator_RowDeletedName="tblAssignmentRowDeleted" msprop:Generator_RowEvArgName="tblAssignmentRowChangeEvent" msprop:Generator_RowChangedName="tblAssignmentRowChanged" msprop:Generator_RowClassName="tblAssignmentRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nAssignmentId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnAssignmentId" msprop:Generator_ColumnPropNameInRow="nAssignmentId" msprop:Generator_ColumnPropNameInTable="nAssignmentIdColumn" msprop:Generator_UserColumnName="nAssignmentId" type="xs:int" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dEmbarked" msprop:Generator_ColumnVarNameInTable="columndEmbarked" msprop:Generator_ColumnPropNameInRow="dEmbarked" msprop:Generator_ColumnPropNameInTable="dEmbarkedColumn" msprop:Generator_UserColumnName="dEmbarked" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nContract" msprop:Generator_ColumnVarNameInTable="columnnContract" msprop:Generator_ColumnPropNameInRow="nContract" msprop:Generator_ColumnPropNameInTable="nContractColumn" msprop:Generator_UserColumnName="nContract" type="xs:int" minOccurs="0" />
              <xs:element name="dLeave" msprop:Generator_ColumnVarNameInTable="columndLeave" msprop:Generator_ColumnPropNameInRow="dLeave" msprop:Generator_ColumnPropNameInTable="dLeaveColumn" msprop:Generator_UserColumnName="dLeave" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nRequest" msprop:Generator_ColumnVarNameInTable="columnnRequest" msprop:Generator_ColumnPropNameInRow="nRequest" msprop:Generator_ColumnPropNameInTable="nRequestColumn" msprop:Generator_UserColumnName="nRequest" type="xs:int" minOccurs="0" />
              <xs:element name="dDuKienRoiTau" msprop:Generator_ColumnVarNameInTable="columndDuKienRoiTau" msprop:Generator_ColumnPropNameInRow="dDuKienRoiTau" msprop:Generator_ColumnPropNameInTable="dDuKienRoiTauColumn" msprop:Generator_UserColumnName="dDuKienRoiTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dSanSangLenTau" msprop:Generator_ColumnVarNameInTable="columndSanSangLenTau" msprop:Generator_ColumnPropNameInRow="dSanSangLenTau" msprop:Generator_ColumnPropNameInTable="dSanSangLenTauColumn" msprop:Generator_UserColumnName="dSanSangLenTau" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dCatHopDong" msprop:Generator_ColumnVarNameInTable="columndCatHopDong" msprop:Generator_ColumnPropNameInRow="dCatHopDong" msprop:Generator_ColumnPropNameInTable="dCatHopDongColumn" msprop:Generator_UserColumnName="dCatHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dNghiHuu" msprop:Generator_ColumnVarNameInTable="columndNghiHuu" msprop:Generator_ColumnPropNameInRow="dNghiHuu" msprop:Generator_ColumnPropNameInTable="dNghiHuuColumn" msprop:Generator_UserColumnName="dNghiHuu" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dKyHopDong" msprop:Generator_ColumnVarNameInTable="columndKyHopDong" msprop:Generator_ColumnPropNameInRow="dKyHopDong" msprop:Generator_ColumnPropNameInTable="dKyHopDongColumn" msprop:Generator_UserColumnName="dKyHopDong" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dModified" msprop:Generator_ColumnVarNameInTable="columndModified" msprop:Generator_ColumnPropNameInRow="dModified" msprop:Generator_ColumnPropNameInTable="dModifiedColumn" msprop:Generator_UserColumnName="dModified" type="xs:dateTime" minOccurs="0" />
              <xs:element name="isActive" msprop:Generator_ColumnVarNameInTable="columnisActive" msprop:Generator_ColumnPropNameInRow="isActive" msprop:Generator_ColumnPropNameInTable="isActiveColumn" msprop:Generator_UserColumnName="isActive" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrew" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblLichHen_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblLichHen" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="tblAssignment_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblAssignment" />
      <xs:field xpath="mstns:nAssignmentId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblAssignment_tblCrew" msdata:parent="tblCrew" msdata:child="tblAssignment" msdata:parentkey="nCrewId" msdata:childkey="nCrewid" msprop:Generator_UserChildTable="tblAssignment" msprop:Generator_ChildPropName="GettblAssignmentRows" msprop:Generator_UserParentTable="tblCrew" msprop:Generator_UserRelationName="FK_tblAssignment_tblCrew" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblCrew" msprop:Generator_ParentPropName="tblCrewRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>